﻿CREATE PROCEDURE [uspDrawerDeleteByField]
	@fieldName nvarchar(100),
	@value nvarchar(1000)
AS
BEGIN
	DECLARE @query nvarchar(2000)
	SET @query = 'DELETE FROM [Drawer] WHERE [' + @fieldName + '] = ''' + @value + ''''
	EXEC(@query)
END